select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Noble Fuchsia Ball Gown Ruffles Quinces Dresses with Embroidery
Ball Gown Strapless Appliques Sweet Sixteen Dresses Hot Sale
Brand New White Ball Gown Dresses for Sweet 16 with Embroidery
Customize Red Ball Gown Embroidery Dresses for Sweet 16 in Tulle
Burgundy Ball Gown Ruching Sweet Sixteen Dresses with Beading
Beading Ball Gown Sweetheart Spring Green Quinces Dresses
Designer Strapless Embroider Orange Quince Dresses Plus
Spaghetti Straps Appliqued Quinces Dresses with Colorful Ruffles
Strapless Embroidery Beading Purple Quince Dress with Pick-ups
Embroidery Deep Sky Blue Quince Dresses with Hand Made Flowers
Beading Embroidery Royal Blue Quinces Dresses with Pick-ups
Strapless Appliqued Quince Party Dress with Colorful Ruffles
Beading Ruffled Hot Pink Sweet 16 Dresses with Lace Up Back
Embroidery Dresses for 15 with Bowknot
Beading Royal Blue Tiered Quinces Dresses with Long Fan Sleeves
Elegant Ball Gown Strapless Dresses for 15 with Pick-ups
Strapless Beading Apple Green Quinceanera Dresses with Appliques
Strapless Baby Blue Dresses for 15 with Colorful Hand Made Flowers
Beading Spring Green Pleated Quinceanera Dresses with Pick-ups
Sweetheart Beading Bodice Hot Pink Dress for Quince with Ruffles
Beading Multi-tiered Lilac Hand Black Quinceanera Dresses
Strapless Rose Pink and White Dresses with Pick-ups
One Shoulder Ruched Light Purple Dress for Quince with Pick-ups
Embroidery Multi-tiered Aqua Blue Quinces Dresses Custom Made
White Strapless Quinceanera Party Dress with Purple Embroidery
Teal Ball Gown Taffeta Dresses of 15 with Pick ups and Appliques
Organza Ball Gown Dresses 15 with Beading and Rolling Flowers
Red Tulle Ball Gown Dresses for A Quince with Black Embroidery
Teal Ball Gown Quinceanera Gown Dresses with Appliques and Pick ups
One Shoulder Aqua Blue Dress for Sweet 16 with Pick-ups